www.gusucode.com > XerCMS 携云PHP企业建站程序 v2015PHP源码程序 > XerCMS 携云PHP企业建站程序 v2015/XerCMS_v20150724/XerCMS_v20150724/XerCMS/Utils/tables/XerCMS_message.php

    <?php
/**
 * @name     XERCMS
 * @author   Arno <XerCMS@163.com> [QQ:1328013]
 * @version  1.0.0
 * @link     http://www.XerCMS.com
 */

!defined('XERCMS') && exit('Access Denied');

class TABLE_message extends resource
{
     private $data = NULL;
     private $defaultTable = 'xercms_message';
	 
	function __construct() {
	 	$this->table = $this->defaultTable;
	} 
	 
     function view($id,$uid = 0) {
	     
		$uid = empty($uid) ? X::$G['uid'] : $uid;
          DB::update('xercms_member_message',array('state'=>1),array('uid'=>$uid,'id'=>$id));
		return DB::result('SELECT m.*,p.nick as sender FROM xercms_member_message m,xercms_member_profile p WHERE p.uid = m.uid and m.uid = '.$uid.' and m.id = '.$id.' LIMIT 1');
	}

     function del($ids,$uid = 0) {    
		$uid = empty($uid) ? X::$G['uid'] : $uid;
		return DB::query('DELETE FROM xercms_member_message WHERE id in ('.$ids.') AND uid = '.X::$G['uid']);
	}

	function count($sate = '0,1',$uid = 0) {
          $state = explode(',',$state);
          foreach($state as $k=>$v) {
               $state[$k] = (int)$v;
          }
          $state = implode(',',$state);     
		$uid = empty($uid) ? X::$G['uid'] : $uid;
	     return DB::result_first('SELECT count(*) FROM xercms_member_message WHERE uid = '.X::$G['uid'].' AND state in ('.$state.')');
	}
	
	function read($page,$state = '0,1',$number = 30,$uid = 0) {	     
		$uid = empty($uid) ? X::$G['uid'] : $uid;
          $state = explode(',',$state);
          foreach($state as $k=>$v) {
               $state[$k] = (int)$v;
          }
          $state = implode(',',$state);
		//exit('SELECT m.*,p.nick as sender FROM xercms_member_message m,xercms_member_profile p WHERE p.uid = m.uid and m.uid = '.X::$G['uid'].' limit '.(($page-1)*$number).','.$number);
	     return DB::fetch_all('SELECT m.*,p.nick as sender FROM xercms_member_message m 
          	LEFT JOIN xercms_member_profile p ON p.uid = m.uid and m.uid = '.X::$G['uid'].'
               WHERE m.state in ('.$state.') limit '.(($page-1)*$number).','.$number);
	}
	
     function rely($id,$uid = 0) {     
		$uid = empty($uid) ? X::$G['uid'] : $uid;
		return DB::result('SELECT title,send FROM xercms_member_message WHERE uid = '.X::$G['uid'].' AND id = '.$id);
	}
}
?>